LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
Marco18+
 
Posts: n/a
Default * next to date format in Formatcells Number tab

Many Thanks!

"Peo Sjoblom" wrote:

It's just indicating a comment about certain formats saying (the format
itself does not use an asterisk)

"Date formats display date and time serial numbers as date values. Except
for items that have an asterisk (*), applied formats do not switch date
orders with the operating system."

So it's not a format using an asterisk but an indicator that certain formats
are different from other formats with regards to the OS

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Marco18+" wrote in message
...
Hi
I've got the UK version of Excel 2003.
What does the * next to a date format within the Type area signify when in
the Formatcells window, in the Number tab, having chosen the Date format?
Any info on this would be appreciated.
Thanks






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
" / " Changing Decimal number format to Fraction on Protected Cell laudie Excel Worksheet Functions 0 November 15th 05 01:12 AM
Help needed with date format [email protected] Excel Discussion (Misc queries) 1 August 29th 05 09:11 AM
Date Format Squirrelly Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 3 August 18th 05 09:43 PM
Compare dates (one cell not in date format) craigcsb Excel Discussion (Misc queries) 5 June 28th 05 05:07 PM
Date Format Question Josh O. Excel Discussion (Misc queries) 1 February 10th 05 09:45 PM


All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"