View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default 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!