View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default how do i reset the default from "general" to "number"

Mike,

I my version of XL that only changes integers into two decimal numbers.
Floating point numbers stay as entered.

--
Reagrds,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
Fog

Toolsoptionsedit tab & check "Fixed decimal Places, then set them to 2
in
the drop down.

Mike Rogers

"Fog" wrote:

Wish to have a two decimal number displayed instead of variable under
general