Converting a whole chart from Megawatts to Gigawatts

Igzie

New member
Joined
Nov 7, 2013
Messages
3
Reaction score
0
Points
0
Hi, I have a chart where I'd like to split every number by 100, to give me i in Gigawatts instead of megawatts. Can it be done?

197914700154002560014300181001080068601310019400132001880020300
1980156001050018900109001100091706790975014200206001710023400
1981221001520014900130001490013700103001260013400151002120019300
19821570010600206001460016500759084201490019800188002270022500
1983268001660017700131001640011900110001070019800257002020024500
19842260011700177001520014300128008930842011100230001990017800
1985154009090194001730011800514098301760017200176001650014000
198619800127002090012300196009800117001250016700198002540024500
1987185001510011900155001380011000115001000016200214001230018700
19882280020500163001370093505580144001120019500162002000021600
1989290002450019600159001630010500107001320012100167001590016900
199024200245002870018200116009410168001270016300182001260021500
19911860020400134001680017100132007140908018300140002080022600
1992224002110020200152001470010200131001740012700164001990020500
199329800170002010014500114007520122001320015100185001490021900
199419600114002360017800107001740067801150016300184001730020700
1995229002290022600161001380011700139001170020200226001650010600
1996108001620015000107001460012300142001450012400186001980018600
1997173002530021900185001240087705620857016900192001290012700
199819800228001710015100109001230094101650013200182001050022400
199918600166002030015500168001420011000884014800189002090023700
20002330018900193001370013200162008630994016000190002060016100
200114300182001270013900132001060097801320013900189002420017200
200221000213002140011200147001230010100639010300181001670016000
20032130091501650016900145001010078201180016500135001330022100
200417500162001710014600144001160084401420017900191001940021700
200525400188001110014000129001130083701090018300170002030023400
20061790015100146001360012000117009090846014700138002360025200
200723600180001760014800172009640138001540020600137001910016900
20082790022300197001110067001310096901240012400228001910014200
200920400717016400113001380010300127001430019400145002200013700
20101330011300158001260096907480140001280016200182002190015500
201119200197002230014400162001180097201220018700217001360024500
201219000176002150014500124001070011600938021200174002420019600
201315700110001460017300198001130010100
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Do you mean 1000?

Anyway enter 100 (or 1000) in any blank cell and copy it.

Then select your range to convert, then right-click Paste Special, and select Divide from the Operation section, click Ok. Now you can delete the 100 in the separate cell.
 

JoePublic

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
234
Reaction score
3
Points
18
Location
UK
Excel Version(s)
2016
You can also change the number format for the chart axis (or data labels).
 
Top