Decimal Point...
Alright... this is so simple but I just can't figure it out. How do I get
Excel to automatically put a decimal point 2 spaces in? And what I mean specifically is if I enter 50030. I want it to put the decimal at 500.30. Help! |
Decimal Point...
If you mean BEFORE beginning to type then goto 'Tools' 'Options...'
'Edit' tab select 'Fixed decimal point' and choose 2 OK. When finished un-select this option. Micky "Zoe" wrote: Alright... this is so simple but I just can't figure it out. How do I get Excel to automatically put a decimal point 2 spaces in? And what I mean specifically is if I enter 50030. I want it to put the decimal at 500.30. Help! |
Decimal Point...
in older version of excel, tools/options/edit/fixed decimal....
"Zoe" wrote: Alright... this is so simple but I just can't figure it out. How do I get Excel to automatically put a decimal point 2 spaces in? And what I mean specifically is if I enter 50030. I want it to put the decimal at 500.30. Help! |
Decimal Point...
So simple! I knew it! Thank you so much!
"Zoe" wrote: Alright... this is so simple but I just can't figure it out. How do I get Excel to automatically put a decimal point 2 spaces in? And what I mean specifically is if I enter 50030. I want it to put the decimal at 500.30. Help! |
Decimal Point...
But do not forget, this will apply to ALL numbers you type
If you want to post-process a range of numbers: Type 100 is some empty cell and copy it Select the range to process and use Edit | Paste Special with Divide specified best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Zoe" wrote in message ... So simple! I knew it! Thank you so much! "Zoe" wrote: Alright... this is so simple but I just can't figure it out. How do I get Excel to automatically put a decimal point 2 spaces in? And what I mean specifically is if I enter 50030. I want it to put the decimal at 500.30. Help! |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com